﻿-- =============================================
-- Author:		<Author,,Name>
-- Create date: <Create Date,,>
-- Description:	<Description,,>
-- =============================================
CREATE PROCEDURE [dbo].[SetDislocationRow]
	-- Add the parameters for the stored procedure here
(	@OperationDateTime DateTime,  
	@CarNumber int,
	@Weight float, 
	@ArrivalStation int, 
	@CargoCode nchar(5), 
	@ConsigneeCode nchar(4), 
	@CarParkType nchar(2), 
	@DispatchStation int, 
	@OperationCode nchar(2),  
	@OperationStation INT, 
	@RoadOfDelivery int, 
	@RoadOfReception int, 
	@TrainIndex nchar(13),
	@TrainNumber nchar(4)

	)
AS
BEGIN
	insert into Dislocation 
				(OperationDateTime, 
				CarNumber, 
				Weight, 
				ArrivalStation, 
				CargoCode, 
				ConsigneeCode, 
				CarParkType, 
				DispatchStation, 
				OperationCode, 
				OperationStation, 
				RoadOfDelivery, 
				RoadOfReception, 
				TrainIndex,
				TrainNumber)
	values (@OperationDateTime, 
				@CarNumber, 
				@Weight, 
				@ArrivalStation, 
				@CargoCode, 
				@ConsigneeCode, 
				@CarParkType, 
				@DispatchStation, 
				@OperationCode,  
				@OperationStation, 
				@RoadOfDelivery, 
				@RoadOfReception, 
				@TrainIndex,
				@TrainNumber)        
END
